<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta charset="UTF-8">
    <link rel="canonical" href="https://blog.csdn.net/qq_37187976/article/details/80494668"/>
    <meta http-equiv="content-type" content="text/html; charset=utf-8">
    <meta name="renderer" content="webkit"/>
    <meta name="force-rendering" content="webkit"/>
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"/>
    <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <meta name="report" content='{"pid":"blog"}'>
    <meta name="referrer" content="always">
    <meta http-equiv="Cache-Control" content="no-siteapp" /><link rel="alternate" media="handheld" href="#" />
    <meta name="shenma-site-verification" content="5a59773ab8077d4a62bf469ab966a63b_1497598848">
        <meta name="csdn-baidu-search"  content='{"autorun":true,"install":true,"keyword":"mysql 查看与修改字符集？ - 咻一咻的博客"}'>
    
    <link href="https://csdnimg.cn/public/favicon.ico" rel="SHORTCUT ICON">
    <title>mysql 查看与修改字符集？ - 咻一咻的博客 - CSDN博客</title>

        
                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/detail-3c56c08d12.min.css">
            
        
            <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/themes/skin3-template/skin3-template-9b39979775.min.css">
        <script type="text/javascript">
        var username = "qq_37187976";
        var blog_address = "https://blog.csdn.net/qq_37187976";
        var static_host = "https://csdnimg.cn/release/phoenix/";
        var currentUserName = "";
        var isShowAds = true;
        var isOwner = false;
        var loginUrl = "http://passport.csdn.net/account/login?from=https://blog.csdn.net/qq_37187976/article/details/80494668"
        var blogUrl = "https://blog.csdn.net/";

        var curSkin = "skin3-template";
        // 收藏所需数据
        var articleTitle = "mysql 查看与修改字符集？";
        var articleDesc = "查看字符集一、查看MySQL数据库服务器和数据库MySQL字符集。mysql&amp;gt;showvariableslike%char%;二、查看MySQL数据表（table）的MySQL字符集。mysql&amp;gt;showtablestatusfromsqlstudy_dblike%countries%;三、查看MySQL数据列（column...";
        // 第四范式所需数据
        var articleTitles = "mysql 查看与修改字符集？ - 咻一咻的博客";
        
        var nickName = "咻一咻";
        var isCorporate = false;
        var subDomainBlogUrl = "https://blog.csdn.net/"
        var digg_base_url = "https://blog.csdn.net/qq_37187976/phoenix/comment";
        var articleDetailUrl = "https://blog.csdn.net/qq_37187976/article/details/80494668";
    </script>
    <script src="https://csdnimg.cn/public/common/libs/jquery/jquery-1.9.1.min.js" type="text/javascript"></script>
    <script src="//g.csdnimg.cn/??fixed-sidebar/1.1.3/fixed-sidebar.js,report/1.0.4/report.js" type="text/javascript"></script>
    <link rel="stylesheet" href="https://csdnimg.cn/public/sandalstrap/1.4/css/sandalstrap.min.css">
    <style>
        .MathJax, .MathJax_Message, .MathJax_Preview{
            display: none
        }
    </style>
</head>
<body class="nodata " > 
    <link rel="stylesheet" href="https://csdnimg.cn/public/common/toolbar/content_toolbar_css/content_toolbar.css">
    <script id="toolbar-tpl-scriptId" src="https://csdnimg.cn/public/common/toolbar/js/content_toolbar.js" type="text/javascript" domain="https://blog.csdn.net/"></script>
<div id="kp_box_476" data-pid="476" data-track-view='{"mod":"kp_popu_476-1490","con":",,"}' data-track-click='{"mod":"kp_popu_476-1490","con":",,"}' data-report-view='{"mod":"kp_popu_476-1490","keyword":""}' data-report-click='{"mod":"kp_popu_476-1490","keyword":""}'><script src="//csdnimg.cn/public/common/indexSuperise/1.1.1/indexSuperise.js?20190111165312"></script><script>window.csdn.indexSuperise({smallMoveImg:'https://img-bss.csdn.net/1565248701607.jpg',bigMoveImg:'https://img-bss.csdn.net/1565248693537.jpg',link:'https://kunyu.csdn.net?p=476&a=1490&c=652&k=&d=1&t=3&dest=https%3A%2F%2Fdeveloper.huaweicloud.com%2Fcompetition%2Fcompetitions%2F1000007620%2Fintroduction%3Futm_source%3Dcsdn%26utm_medium%3Dpr%26utm_campaign%3Dcsdntf%26utm_term%3Dgarbage',trackSuperId:476,smallMove:'notMove',trackSId:1490});</script></div><link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/blog_code-c3a0c33d5c.css">
<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-e040f0c7c8.css">

<script type="text/javascript">
	var NEWS_FEED = function(){}
</script>

<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/chart-3456820cac.css" />
<div class="container clearfix" id="mainBox">
			<div class="recommend-right">
  <ul class="recommend-fixed-box">
    
  </ul>
</div>	    <main>
        <div class="blog-content-box">
    <div class="article-header-box">
        <div class="article-header">
            <div class="article-title-box">
                <span class="article-type type-1 float-left">原</span>                <h1 class="title-article">mysql 查看与修改字符集？</h1>
            </div>
            <div class="article-info-box">
                <div class="article-bar-top">
                                                                                                                                            <span class="time">2018年05月29日 12:21:15</span>
                    <a class="follow-nickName" href="https://me.csdn.net/qq_37187976" target="_blank">咻一咻</a>
                    <span class="read-count">阅读数 2404</span>
                                                                                                                                </div>
                <div class="operating">
                                    </div>
            </div>
        </div>
    </div>
    <article class="baidu_pl">
                <div id="article_content" class="article_content clearfix">
                                                <div class="article-copyright">
                                                    <svg class="icon" title="CSDN认证原创" aria-hidden="true"
                                 style="width:53px; height: 18px; vertical-align: -4px;">
                                <use xlink:href="#CSDN_Cert"></use>
                            </svg>
                        
                        版权声明：本文为博主原创文章，未经博主允许不得转载。                        <a class="copy-right-url" href=" https://blog.csdn.net/qq_37187976/article/details/80494668"> https://blog.csdn.net/qq_37187976/article/details/80494668</a>
                    </div>
                                                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/ck_htmledit_views-3019150162.css" />
                                        <div id="content_views" class="markdown_views prism-atom-one-dark">
                    <!-- flowchart 箭头图标 勿删 -->
                    <svg xmlns="http://www.w3.org/2000/svg" style="display: none;">
                        <path stroke-linecap="round" d="M5,0 0,2.5 5,5z" id="raphael-marker-block" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"></path>
                    </svg>
                                            <h2 id="查看字符集">查看字符集</h2>

<p>一、查看MySQL数据库服务器和数据库MySQL字符集。</p>

<pre class="prettyprint"><code class=" hljs vbnet">mysql&gt; show variables <span class="hljs-keyword">like</span> <span class="hljs-comment">'%char%';  </span></code></pre>

<p>二、查看MySQL数据表（table）的MySQL字符集。</p>



<pre class="prettyprint"><code class=" hljs vbnet">mysql&gt; show table status <span class="hljs-keyword">from</span> sqlstudy_db <span class="hljs-keyword">like</span> <span class="hljs-comment">'%countries%';  </span></code></pre>

<p>三、查看MySQL数据列（column）的MySQL字符集。</p>



<pre class="prettyprint"><code class=" hljs cs">mysql&gt; show full columns <span class="hljs-keyword">from</span> countries;  </code></pre>



<h2 id="修改字符集">修改字符集</h2>



<pre class="prettyprint"><code class=" hljs makefile">[root@Centos7 bin]<span class="hljs-comment">#vim /etc/my.cnf</span>
[mysqld]
<span class="hljs-constant">datadir</span>=/data/mysql
<span class="hljs-constant">port</span>            = 3306
<span class="hljs-constant">socket</span>          = /tmp/mysql.sock
<span class="hljs-constant">character_set_server</span>=utf8</code></pre>                                    </div>
                <link href="https://csdnimg.cn/release/phoenix/mdeditor/markdown_views-e44c3c0e64.css" rel="stylesheet">
                    </div>
    </article>
</div>

            <div class="hide-article-box hide-article-pos text-center">
            <a class="btn-readmore" data-report-view='{"mod":"popu_376","dest":"https://blog.csdn.net/qq_37187976/article/details/80494668","strategy":"readmore"}' data-report-click='{"mod":"popu_376","dest":"https://blog.csdn.net/qq_37187976/article/details/80494668","strategy":"readmore"}'>
                展开阅读全文
                <svg class="icon chevrondown" aria-hidden="true">
                    <use xlink:href="#csdnc-chevrondown"></use>
                </svg>
            </a>
        </div>
    
<script>
    $(".MathJax").remove();
    if ($('div.markdown_views pre.prettyprint code.hljs').length > 0) {
        $('div.markdown_views')[0].className = 'markdown_views';
    }
    var persentSet = 1;
</script>

<script src="https://csdnimg.cn/release/phoenix/vendor/linkCatcher/linkCatcher-3a08af3a5f.js"></script>        <div id="dmp_ad_58"><div id="kp_box_58" data-pid="58" data-track-view='{"mod":"kp_popu_58-402","con":",,"}' data-track-click='{"mod":"kp_popu_58-402","con":",,"}' data-report-view='{"mod":"kp_popu_58-402","keyword":""}' data-report-click='{"mod":"kp_popu_58-402","keyword":""}'><div style="width:100%;background:#fff;border:3px solid #fff;padding:16px 0px 0px 0px;">
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<div id="three_ad1" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 100,
                showid : 'ztvJV8',
                placeholderId: "three_ad1",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 0,
                    imageWidth: 90,
                    imageHeight: 68,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft YaHei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 20,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script>
</div></div></div>        <a id="commentBox"></a>
<div class="comment-box">
	
	<div class="comment-edit-box d-flex">
		<a id="commentsedit"></a>
		<div class="user-img">
			<a href="javascript:void(0);" target="_blank">
				<img class="show_loginbox" src="//g.csdnimg.cn/static/user-img/anonymous-User-img.png">
			</a>
		</div>
		<form id="commentform">
			<input type="hidden" id="comment_replyId">
			<textarea class="comment-content" name="comment_content" id="comment_content" placeholder="想对作者说点什么"></textarea>
			<div class="opt-box"> <!-- d-flex -->
				<div id="ubbtools" class="add_code">
					<a href="#insertcode" code="code" target="_self"><i class="icon iconfont icon-daima"></i></a>
				</div>
				<input type="hidden" id="comment_replyId" name="comment_replyId">
				<input type="hidden" id="article_id" name="article_id" value="80494668">
				<input type="hidden" id="comment_userId" name="comment_userId" value="">
				<input type="hidden" id="commentId" name="commentId" value="">
				<div style="display: none;" class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_384","dest":""}'><a href="#" target="_blank" class="comment_area_btn">发表评论</a></div>
				<div class="dropdown" id="myDrap">
					<a class="dropdown-face d-flex align-items-center" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">
					<div class="txt-selected text-truncate">添加代码片</div>
					<svg class="icon d-block" aria-hidden="true">
						<use xlink:href="#csdnc-triangledown"></use>
					</svg>
					</a>
					<ul class="dropdown-menu" id="commentCode" aria-labelledby="drop4">
						<li><a data-code="html">HTML/XML</a></li>
						<li><a data-code="objc">objective-c</a></li>
						<li><a data-code="ruby">Ruby</a></li>
						<li><a data-code="php">PHP</a></li>
						<li><a data-code="csharp">C</a></li>
						<li><a data-code="cpp">C++</a></li>
						<li><a data-code="javascript">JavaScript</a></li>
						<li><a data-code="python">Python</a></li>
						<li><a data-code="java">Java</a></li>
						<li><a data-code="css">CSS</a></li>
						<li><a data-code="sql">SQL</a></li>
						<li><a data-code="plain">其它</a></li>
					</ul>
				</div>  
				<div class="right-box">
					<span id="tip_comment" class="tip">还能输入<em>1000</em>个字符</span>
					<input type="button" class="btn btn-sm btn-cancel d-none" value="取消回复">
					<input type="submit" class="btn btn-sm btn-red btn-comment" value="发表评论">
				</div>
			</div>
		</form>
	</div>

		<div class="comment-list-container">
		<a id="comments"></a>
		<div class="comment-list-box">
		</div>
		<div id="commentPage" class="pagination-box d-none"></div>
		<div class="opt-box text-center">
			<div class="btn btn-sm btn-link-blue" id="btnMoreComment"></div>
		</div>
	</div>
</div>
        <div class="recommend-box">
                            <div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/ghosind/article/details/83692869","strategy":"BlogCommendFromAutoMl2","index":"0"}'>
	<div class="content">
		<a href="https://blog.csdn.net/ghosind/article/details/83692869" target="_blank" title="MySQL查看、修改字符集及Collation">
		<h4 class="text-truncate oneline">
				<em>MySQL</em><em>查看</em>、<em>修改</em><em>字符集</em>及Collation		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-04</span>
				<span class="read-num hover-hide">
					阅读数 
					3482</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/ghosind/article/details/83692869" target="_blank" title="MySQL查看、修改字符集及Collation">
				<span class="desc oneline">前言在使用MySQL的过程中，可能会出现初始设计使用的字符集或Collation不符合当前需求的情况。如使用utf8的表（MySQL中的utf8即utf8mb3）要支持emoji，而utf8mb3不支...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/ghosind">来自：	<span class="blog_title"> Ghosind</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/haogexiaole/article/details/80739503","strategy":"BlogCommendFromAutoMl2","index":"1"}'>
	<div class="content">
		<a href="https://blog.csdn.net/haogexiaole/article/details/80739503" target="_blank" title="mysql修改和查看字符集（数据库全局、schema、表、列）">
		<h4 class="text-truncate oneline">
				<em>mysql</em><em>修改</em>和<em>查看</em><em>字符集</em>（数据库全局、schema、表、列）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-19</span>
				<span class="read-num hover-hide">
					阅读数 
					6628</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/haogexiaole/article/details/80739503" target="_blank" title="mysql修改和查看字符集（数据库全局、schema、表、列）">
				<span class="desc oneline">一、查看字符集1.查看MYSQL数据库服务器和数据库字符集方法一：showvariableslike'%character%';方法二：showvariableslike'collation%';my...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/haogexiaole">来自：	<span class="blog_title"> haogexiaole的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/jc0803kevin/article/details/81587167","strategy":"BlogCommendFromAutoMl2","index":"2"}'>
	<div class="content">
		<a href="https://blog.csdn.net/jc0803kevin/article/details/81587167" target="_blank" title="MySQL字符集设置">
		<h4 class="text-truncate oneline">
				<em>MySQL</em><em>字符集</em>设置		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-11</span>
				<span class="read-num hover-hide">
					阅读数 
					1119</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/jc0803kevin/article/details/81587167" target="_blank" title="MySQL字符集设置">
				<span class="desc oneline">MySQL字符集设置•系统变量：–character_set_server：默认的内部操作字符集–character_set_client：客户端来源数据使用的字符集–character_set_co...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/jc0803kevin">来自：	<span class="blog_title"> Jc0803kevin的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/lzghxjt/article/details/80357119","strategy":"BlogCommendFromAutoMl2","index":"3"}'>
	<div class="content">
		<a href="https://blog.csdn.net/lzghxjt/article/details/80357119" target="_blank" title="mysql字符集问题">
		<h4 class="text-truncate oneline">
				<em>mysql</em><em>字符集</em>问题		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-17</span>
				<span class="read-num hover-hide">
					阅读数 
					569</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/lzghxjt/article/details/80357119" target="_blank" title="mysql字符集问题">
				<span class="desc oneline">一、查询结果乱码：使用mysql执行select命令后查到的结果如果含有汉字时会出现乱码，执行showvariableslike'character%'，获取字符集配置为：latin1其实就是我们通常...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/lzghxjt">来自：	<span class="blog_title"> 鹤啸九天</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_59" data-pid="59" data-track-view='{"mod":"kp_popu_59-860","con":",,SQL"}' data-track-click='{"mod":"kp_popu_59-860","con":",,SQL"}' data-report-view='{"mod":"kp_popu_59-860","keyword":"SQL"}' data-report-click='{"mod":"kp_popu_59-860","keyword":"SQL"}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/109?positionId=59&queryWord=SQL" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/wheat_ground/article/details/78887055","strategy":"BlogCommendFromAutoMl2","index":"4"}'>
	<div class="content">
		<a href="https://blog.csdn.net/wheat_ground/article/details/78887055" target="_blank" title="查看MySQL字符集的方法">
		<h4 class="text-truncate oneline">
				<em>查看</em><em>MySQL</em><em>字符集</em>的方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-24</span>
				<span class="read-num hover-hide">
					阅读数 
					4800</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/wheat_ground/article/details/78887055" target="_blank" title="查看MySQL字符集的方法">
				<span class="desc oneline">查看MySQL字符集的方法查看MySQL数据库服务器和数据库MySQL字符集mysql&gt;showvariableslike'%char%';+--------------------------+--...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/wheat_ground">来自：	<span class="blog_title"> 麦子地的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/bjgaocp/article/details/88106455","strategy":"BlogCommendFromBaidu","index":"5"}'>
	<div class="content">
		<a href="https://blog.csdn.net/bjgaocp/article/details/88106455" target="_blank" title="MySQL字符集">
		<h4 class="text-truncate oneline">
				<em>MySQL</em><em>字符集</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-04</span>
				<span class="read-num hover-hide">
					阅读数 
					328</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/bjgaocp/article/details/88106455" target="_blank" title="MySQL字符集">
				<span class="desc oneline">查看MySQL支持的字符集mysql&amp;amp;gt;showcharacterset;查看mysql当前字符集mysql&amp;amp;gt;showvariableslike‘character_set%...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/bjgaocp">来自：	<span class="blog_title"> bjgaocp的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/L_BestCoder/article/details/53524730","strategy":"BlogCommendFromBaidu","index":"6"}'>
	<div class="content">
		<a href="https://blog.csdn.net/L_BestCoder/article/details/53524730" target="_blank" title="MySQL数据库字符集详解（适合初学者）">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>数据库<em>字符集</em>详解（适合初学者）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-08</span>
				<span class="read-num hover-hide">
					阅读数 
					2686</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/L_BestCoder/article/details/53524730" target="_blank" title="MySQL数据库字符集详解（适合初学者）">
				<span class="desc oneline">MySQL数据库字符集问题1.查看mysql所支持的字符集指令：SHOWCHARACTERSET;很多很多，这里就不全部放上来了，这里的charset代表字符集，就是编码对应字符的集合，后面的coll...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/L_BestCoder">来自：	<span class="blog_title"> LiQiyao的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_37789586/article/details/80044977","strategy":"BlogCommendFromBaidu","index":"7"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_37789586/article/details/80044977" target="_blank" title="MySQL默认字符集问题">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>默认<em>字符集</em>问题		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-23</span>
				<span class="read-num hover-hide">
					阅读数 
					1976</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_37789586/article/details/80044977" target="_blank" title="MySQL默认字符集问题">
				<span class="desc oneline">    create table Student(Sno char(8) NOT NULL primary key,Sname varchar(8) NOT NULL,Sex char(2) NOT ...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_37789586">来自：	<span class="blog_title"> qq_37789586的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/q8692016/article/details/20555913","strategy":"BlogCommendFromBaidu","index":"8"}'>
	<div class="content">
		<a href="https://blog.csdn.net/q8692016/article/details/20555913" target="_blank" title="MySQL 插入数据时，中文乱码问题的解决。">
		<h4 class="text-truncate oneline">
				<em>MySQL</em> 插入数据时，中文乱码问题的解决。		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-05</span>
				<span class="read-num hover-hide">
					阅读数 
					491</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/q8692016/article/details/20555913" target="_blank" title="MySQL 插入数据时，中文乱码问题的解决。">
				<span class="desc oneline">当向MySQL数据库插入一条带有中文的数据形如 insertintoemployeevalues(null,'张三','female','1995-10-08','2015-11-12','Sales...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/q8692016">来自：	<span class="blog_title"> 小童鞋_成er个人博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_60" data-pid="60" data-track-view='{"mod":"kp_popu_60-43","con":",,"}' data-track-click='{"mod":"kp_popu_60-43","con":",,"}' data-report-view='{"mod":"kp_popu_60-43","keyword":""}' data-report-click='{"mod":"kp_popu_60-43","keyword":""}'><div id="three_ad8" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad8",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_38102771/article/details/88593225","strategy":"BlogCommendFromBaidu","index":"9"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_38102771/article/details/88593225" target="_blank" title="编码和字符集，MySQL字符集参数详解">
		<h4 class="text-truncate oneline">
				编码和<em>字符集</em>，<em>MySQL</em><em>字符集</em>参数详解		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-16</span>
				<span class="read-num hover-hide">
					阅读数 
					120</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_38102771/article/details/88593225" target="_blank" title="编码和字符集，MySQL字符集参数详解">
				<span class="desc oneline">编码问题计算机的世界里只有0和1，而对于人类有图片声音文字等，那么计算机如何存储这些图片文字等信息呢，对于01000001，如果要看成数字，那就是65，如果要看成字符，那就是'A'，对于这样的规则，就...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_38102771">来自：	<span class="blog_title"> 梦别停的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/w36680130/article/details/81029615","strategy":"BlogCommendFromAutoMl2","index":"10"}'>
	<div class="content">
		<a href="https://blog.csdn.net/w36680130/article/details/81029615" target="_blank" title="如何修改MySQL字符集">
		<h4 class="text-truncate oneline">
				如何<em>修改</em><em>MySQL</em><em>字符集</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-13</span>
				<span class="read-num hover-hide">
					阅读数 
					2667</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/w36680130/article/details/81029615" target="_blank" title="如何修改MySQL字符集">
				<span class="desc oneline">　　首先，MySQL的字符集问题主要是两个概念，一个是CharacterSets，一个是Collations，前者是字符内容及编码，后者是对前者进行比较操作的一些规则。这两个参数集可以在数据库实例、...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/w36680130">来自：	<span class="blog_title"> w36680130的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
			<div class="recommend-item-box blog-expert-recommend-box">
			<div class="d-flex">
				<div class="blog-expert-recommend">
					<div class="blog-expert">
						<div class="blog-expert-flexbox"></div>
					</div>
				</div>
			</div>
		</div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_38712932/article/details/78766180","strategy":"BlogCommendFromAutoMl2","index":"11"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_38712932/article/details/78766180" target="_blank" title="Windows mysql默认字符集修改">
		<h4 class="text-truncate oneline">
				Windows <em>mysql</em>默认<em>字符集</em><em>修改</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-10</span>
				<span class="read-num hover-hide">
					阅读数 
					122</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_38712932/article/details/78766180" target="_blank" title="Windows mysql默认字符集修改">
				<span class="desc oneline">Windowsmysql默认字符集修改一、通过MySQL命令行修改:setcharacter_set_client=utf8;setcharacter_set_connection=utf8;setc...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_38712932">来自：	<span class="blog_title"> Anoni的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_33912445/article/details/88512225","strategy":"BlogCommendFromAutoMl2","index":"12"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_33912445/article/details/88512225" target="_blank" title="Mysql-2">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>-2		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-23</span>
				<span class="read-num hover-hide">
					阅读数 
					3</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_33912445/article/details/88512225" target="_blank" title="Mysql-2">
				<span class="desc oneline">MySql-21.1字符集字符集：可见字符在保存和传输的时候对应的二进制代码集合。字符集在两个地方用到1.保存数据2.数据传输1.2在存续时使用字符集1、MySQL可以在服务器上、数据库、表、字段上指...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_33912445">来自：	<span class="blog_title"> weixin_33912445的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/llyyxx0088/article/details/80062139","strategy":"BlogCommendFromAutoMl2","index":"13"}'>
	<div class="content">
		<a href="https://blog.csdn.net/llyyxx0088/article/details/80062139" target="_blank" title="MySQL 8.0.11 字符集">
		<h4 class="text-truncate oneline">
				<em>MySQL</em> 8.0.11 <em>字符集</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-24</span>
				<span class="read-num hover-hide">
					阅读数 
					4858</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/llyyxx0088/article/details/80062139" target="_blank" title="MySQL 8.0.11 字符集">
				<span class="desc oneline">字符集：是一套符号和编码校对规则：是在字符集内用于比较字符的一套规则字符集生效规则：Table继承于Database，Database继承于Server，就是说，可只设置character_set_s...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/llyyxx0088">来自：	<span class="blog_title"> yxli的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_61" data-pid="61" data-track-view='{"mod":"kp_popu_61-557","con":",,"}' data-track-click='{"mod":"kp_popu_61-557","con":",,"}' data-report-view='{"mod":"kp_popu_61-557","keyword":""}' data-report-click='{"mod":"kp_popu_61-557","keyword":""}'><div id="three_ad13" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad13",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/sin90lzc/article/details/7648439","strategy":"BlogCommendFromAutoMl2","index":"14"}'>
	<div class="content">
		<a href="https://blog.csdn.net/sin90lzc/article/details/7648439" target="_blank" title="MySQL字符集的设置">
		<h4 class="text-truncate oneline">
				<em>MySQL</em><em>字符集</em>的设置		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-09</span>
				<span class="read-num hover-hide">
					阅读数 
					3万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/sin90lzc/article/details/7648439" target="_blank" title="MySQL字符集的设置">
				<span class="desc oneline">Notice:文章基于ubuntu系统而写1.关于MySQL字符集MySQL的字符集支持(CharacterSetSupport)有两个方面：  字符集(Characterset)和排序方式(Coll...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/sin90lzc">来自：	<span class="blog_title"> 让梦想从这里起飞……</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/ajax_yan/article/details/88423018","strategy":"BlogCommendFromBaidu","index":"15"}'>
	<div class="content">
		<a href="https://blog.csdn.net/ajax_yan/article/details/88423018" target="_blank" title="mysql修改字符集编码">
		<h4 class="text-truncate oneline">
				<em>mysql</em><em>修改</em><em>字符集</em>编码		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-12</span>
				<span class="read-num hover-hide">
					阅读数 
					286</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/ajax_yan/article/details/88423018" target="_blank" title="mysql修改字符集编码">
				<span class="desc oneline">找到my.ini,新版mysql配置文件my.ini在programData下面的mysql5.7下面找在[client]下添加default-character-set=utf8在[mysql]下添...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/ajax_yan">来自：	<span class="blog_title"> ajax_yan的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/ma15732625261/article/details/80680423","strategy":"BlogCommendFromBaidu","index":"16"}'>
	<div class="content">
		<a href="https://blog.csdn.net/ma15732625261/article/details/80680423" target="_blank" title="【mysql】字符集、字符序、分词查询">
		<h4 class="text-truncate oneline">
				【<em>mysql</em>】<em>字符集</em>、字符序、分词查询		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-21</span>
				<span class="read-num hover-hide">
					阅读数 
					1361</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/ma15732625261/article/details/80680423" target="_blank" title="【mysql】字符集、字符序、分词查询">
				<span class="desc oneline">前言：  以下内容毫不客气滴说：均来自网络 上面的三个词混着在正文中正文：Mysql5.6分词查询：和5.7稍微有些差别详情见：https://www.cnblogs.com/ibook360/p/5...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/ma15732625261">来自：	<span class="blog_title"> 星小丫头辰</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34009794/article/details/86401538","strategy":"BlogCommendFromBaidu","index":"17"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_34009794/article/details/86401538" target="_blank" title="mysql字符集">
		<h4 class="text-truncate oneline">
				<em>mysql</em><em>字符集</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-13</span>
				<span class="read-num hover-hide">
					阅读数 
					11</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_34009794/article/details/86401538" target="_blank" title="mysql字符集">
				<span class="desc oneline">gb2312简体中文已经常用符号，双字节编码gbk中日韩字符，是gb2312的超集，也是双字节编码utf8多字节编码。包含中日韩法俄字符，特别注意，还包含英文字符，对于英文字符，使用一个字节，其他字符...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_34009794">来自：	<span class="blog_title"> weixin_34009794的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/jayzym/article/details/52735314","strategy":"BlogCommendFromBaidu","index":"18"}'>
	<div class="content">
		<a href="https://blog.csdn.net/jayzym/article/details/52735314" target="_blank" title="linux 系统下修改Mysql默认字符集">
		<h4 class="text-truncate oneline">
				linux 系统下<em>修改</em><em>Mysql</em>默认<em>字符集</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-04</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/jayzym/article/details/52735314" target="_blank" title="linux 系统下修改Mysql默认字符集">
				<span class="desc oneline">linux系统版本Ubuntu14.04.1  Mysql版本5.7.15    这几天在做管理系统时，做完之后放到前一段购买的腾讯云上测试，发现请求数据发送后显示为乱码，但是在本地测试时却没有发生这...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/jayzym">来自：	<span class="blog_title"> jayzym的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_62" data-pid="62" data-track-view='{"mod":"kp_popu_62-556","con":",,"}' data-track-click='{"mod":"kp_popu_62-556","con":",,"}' data-report-view='{"mod":"kp_popu_62-556","keyword":""}' data-report-click='{"mod":"kp_popu_62-556","keyword":""}'><div id="three_ad18" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad18",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_36910300/article/details/79126096","strategy":"BlogCommendFromBaidu","index":"19"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_36910300/article/details/79126096" target="_blank" title="MySQL选择合适的字符集">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>选择合适的<em>字符集</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-22</span>
				<span class="read-num hover-hide">
					阅读数 
					1318</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_36910300/article/details/79126096" target="_blank" title="MySQL选择合适的字符集">
				<span class="desc oneline">对数据库来说，字符集更加重要，因为数据库存储的数据大部分都是各种文字，字符集对数据库的存储，处理性能，以及日后系统的移植，推广都会有影响。MySQL5.6目前支持几十种字符集，包括UCS-2，UTF-...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_36910300">来自：	<span class="blog_title"> 小白</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/luguo0816/article/details/7203040","strategy":"BlogCommendFromAutoMl2","index":"20"}'>
	<div class="content">
		<a href="https://blog.csdn.net/luguo0816/article/details/7203040" target="_blank" title="mysql模式Strict Mode">
		<h4 class="text-truncate oneline">
				<em>mysql</em>模式Strict Mode		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-15</span>
				<span class="read-num hover-hide">
					阅读数 
					2714</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/luguo0816/article/details/7203040" target="_blank" title="mysql模式Strict Mode">
				<span class="desc oneline">http://www.dangkai.com/ArticlePage/Article8660.htmMySQL模式:StrictModeI.StrictMode阐述根据mysql5.0以上版本stri...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/luguo0816">来自：	<span class="blog_title"> luguo0816的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_34329522/article/details/80948636","strategy":"BlogCommendFromAutoMl2","index":"21"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_34329522/article/details/80948636" target="_blank" title="mysql 设置字符集">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 设置<em>字符集</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-07</span>
				<span class="read-num hover-hide">
					阅读数 
					1477</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_34329522/article/details/80948636" target="_blank" title="mysql 设置字符集">
				<span class="desc oneline">功能：让mysql数据库能够支持中文，必须设置系统字符集编码输入命令：showvariableslike‘char%’;可以查看当前连接系统的情况然后输入setcharacter_set_databa...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_34329522">来自：	<span class="blog_title"> 周子博的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_40809549/article/details/79851992","strategy":"BlogCommendFromAutoMl2","index":"22"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_40809549/article/details/79851992" target="_blank" title="关于mysql字符集的修改">
		<h4 class="text-truncate oneline">
				关于<em>mysql</em><em>字符集</em>的<em>修改</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-08</span>
				<span class="read-num hover-hide">
					阅读数 
					653</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_40809549/article/details/79851992" target="_blank" title="关于mysql字符集的修改">
				<span class="desc oneline">按照下述修改mysql配置文件，重启生效==================================================[client]default-character-set=...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_40809549">来自：	<span class="blog_title"> 胡子的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u012410733/article/details/61619656","strategy":"BlogCommendFromAutoMl2","index":"23"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u012410733/article/details/61619656" target="_blank" title="彻底解决mysql中文乱码">
		<h4 class="text-truncate oneline">
				彻底解决<em>mysql</em>中文乱码		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-12</span>
				<span class="read-num hover-hide">
					阅读数 
					16万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u012410733/article/details/61619656" target="_blank" title="彻底解决mysql中文乱码">
				<span class="desc oneline">mysql是我们项目中非常常用的数据型数据库。但是因为我们需要在数据库保存中文字符，所以经常遇到数据库乱码情况。下面就来介绍一下如何彻底解决数据库中文乱码情况。...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u012410733">来自：	<span class="blog_title"> carl.zhao的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_63" data-pid="63" data-track-view='{"mod":"kp_popu_63-555","con":",,"}' data-track-click='{"mod":"kp_popu_63-555","con":",,"}' data-report-view='{"mod":"kp_popu_63-555","keyword":""}' data-report-click='{"mod":"kp_popu_63-555","keyword":""}'><div id="three_ad23" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad23",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_37257657/article/details/80973099","strategy":"BlogCommendFromAutoMl2","index":"24"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_37257657/article/details/80973099" target="_blank" title="MySQL中utf8字符集、排序规则及utf8mb4_bin列大小写不敏感方法">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>中utf8<em>字符集</em>、排序规则及utf8mb4_bin列大小写不敏感方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-09</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_37257657/article/details/80973099" target="_blank" title="MySQL中utf8字符集、排序规则及utf8mb4_bin列大小写不敏感方法">
				<span class="desc oneline">转载：https://my.oschina.net/u/1245414/blog/1831347一、utf8mb4和utf8比较utf8mb4:AUTF-8encodingoftheUnicodech...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_37257657">来自：	<span class="blog_title"> qq_37257657的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/kobejayandy/article/details/17288917","strategy":"BlogCommendFromBaidu","index":"25"}'>
	<div class="content">
		<a href="https://blog.csdn.net/kobejayandy/article/details/17288917" target="_blank" title="MySQL中涉及的几个字符集">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>中涉及的几个<em>字符集</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-12</span>
				<span class="read-num hover-hide">
					阅读数 
					660</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/kobejayandy/article/details/17288917" target="_blank" title="MySQL中涉及的几个字符集">
				<span class="desc oneline">character-set-server/default-character-set：服务器字符集，默认情况下所采用的。character-set-database：数据库字符集。character-...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/kobejayandy">来自：	<span class="blog_title"> kobejayandy的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
	<div class="recommend-item-box  recommend-download-box clearfix"  data-report-click='{"mod":"popu_387","dest":"https://download.csdn.net/download/lvxchen/10357141","strategy":"BlogCommendFromBaidu","index":"26"}'>
		<a href="https://download.csdn.net/download/lvxchen/10357141" target="_blank">
			<div class="content clearfix">
				<div class="">
					<h4 class="text-truncate oneline clearfix">
						关于<em>MySQL</em><em>字符集</em><em>查看</em>与<em>修改</em>					</h4>
					<span class="data float-right">04-18</span>
				</div>
				<div class="desc oneline">
						关于MySQL字符集查看与修改; MySQL的字符集支持(Character Set Support)有两个方面：   字符集(Character set)和排序方式(Collation)。 MySQ				</div>
				<span class="type-show type-show-download">下载</span>
			</div>
		</a>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/kk185800961/article/details/61210090","strategy":"BlogCommendFromBaidu","index":"27"}'>
	<div class="content">
		<a href="https://blog.csdn.net/kk185800961/article/details/61210090" target="_blank" title="MySQL 字符集编码及乱码问题">
		<h4 class="text-truncate oneline">
				<em>MySQL</em> <em>字符集</em>编码及乱码问题		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-10</span>
				<span class="read-num hover-hide">
					阅读数 
					1715</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/kk185800961/article/details/61210090" target="_blank" title="MySQL 字符集编码及乱码问题">
				<span class="desc oneline">最常见的问题就是数据库插入查看或导入导出出现了乱码，这应该是所有用过mysql的人都遇到过了吧。所以解决乱码问题，就应该理解其原因：就是客户端连接设置的编码与表编码不一致！...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/kk185800961">来自：	<span class="blog_title"> KK 笔记：专注数据</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/symgdwyh/article/details/4419366","strategy":"BlogCommendFromBaidu","index":"28"}'>
	<div class="content">
		<a href="https://blog.csdn.net/symgdwyh/article/details/4419366" target="_blank" title="mysql查看和修改字符集的命令">
		<h4 class="text-truncate oneline">
				<em>mysql</em><em>查看</em>和<em>修改</em><em>字符集</em>的命令		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-06</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/symgdwyh/article/details/4419366" target="_blank" title="mysql查看和修改字符集的命令">
				<span class="desc oneline">Liunx下修改MySQL字符集：1.查找MySQL的cnf文件的位置find/-iname*.cnf-print/usr/share/mysql/my-innodb-heavy-4G.cnf/usr...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/symgdwyh">来自：	<span class="blog_title"> symgdwyh的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_64" data-pid="64" data-track-view='{"mod":"kp_popu_64-81","con":",,"}' data-track-click='{"mod":"kp_popu_64-81","con":",,"}' data-report-view='{"mod":"kp_popu_64-81","keyword":""}' data-report-click='{"mod":"kp_popu_64-81","keyword":""}'><div id="three_ad28" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad28",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/shenlan211314/article/details/6436967","strategy":"BlogCommendFromBaidu","index":"29"}'>
	<div class="content">
		<a href="https://blog.csdn.net/shenlan211314/article/details/6436967" target="_blank" title="查看修改MySQL字符集">
		<h4 class="text-truncate oneline">
				<em>查看</em><em>修改</em><em>MySQL</em><em>字符集</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-21</span>
				<span class="read-num hover-hide">
					阅读数 
					2万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/shenlan211314/article/details/6436967" target="_blank" title="查看修改MySQL字符集">
				<span class="desc oneline">==查看字符集== //查看MySQL数据库服务器和数据库字符集showvariableslike'%char%';//查看表的字符集showtablestatusfrommysql_dblike'%...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/shenlan211314">来自：	<span class="blog_title"> 张林林|深蓝(Linlin Zhang,shenlan211314) 的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_33841722/article/details/86316115","strategy":"BlogCommendFromAutoMl2","index":"30"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_33841722/article/details/86316115" target="_blank" title="mysql修改表、字段、库的字符集">
		<h4 class="text-truncate oneline">
				<em>mysql</em><em>修改</em>表、字段、库的<em>字符集</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-26</span>
				<span class="read-num hover-hide">
					阅读数 
					6</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_33841722/article/details/86316115" target="_blank" title="mysql修改表、字段、库的字符集">
				<span class="desc oneline">在一次导入数据表(MYISAM)的经历：复制过来的表打开后中文出现乱码，肯定是字符集出现了不致的问题，所以从原数据库导出.sql文件，修改其中的创建表的语句，加入字符集DEFAULTCHARSET=g...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_33841722">来自：	<span class="blog_title"> weixin_33841722的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/wssg3620625/article/details/37334309","strategy":"BlogCommendFromAutoMl2","index":"31"}'>
	<div class="content">
		<a href="https://blog.csdn.net/wssg3620625/article/details/37334309" target="_blank" title="mysql字符集设置">
		<h4 class="text-truncate oneline">
				<em>mysql</em><em>字符集</em>设置		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-06</span>
				<span class="read-num hover-hide">
					阅读数 
					1667</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/wssg3620625/article/details/37334309" target="_blank" title="mysql字符集设置">
				<span class="desc oneline">最近一直在弄一个有关mysql proxy的项目，中间涉及到对sql语句的解析。之前对mysql了解的并不是太多，随着项目的推进，不得不补补了。今天突然看到mysql的charset设置，自己很多地方...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/wssg3620625">来自：	<span class="blog_title"> wssg3620625的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_18377515/article/details/82555896","strategy":"BlogCommendFromAutoMl2","index":"32"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_18377515/article/details/82555896" target="_blank" title="MySql 	字符集和校对">
		<h4 class="text-truncate oneline">
				<em>MySql</em> 	<em>字符集</em>和校对		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-09</span>
				<span class="read-num hover-hide">
					阅读数 
					219</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_18377515/article/details/82555896" target="_blank" title="MySql 	字符集和校对">
				<span class="desc oneline">基本信息字符集和排序规则的级别官网地址：https://dev.mysql.com/doc/refman/5.7/en/charset.html字符集是指一种从二进制编码到某类字符符号的映射，校对是指...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_18377515">来自：	<span class="blog_title"> shareing</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/iastro/article/details/45914985","strategy":"BlogCommendFromAutoMl2","index":"33"}'>
	<div class="content">
		<a href="https://blog.csdn.net/iastro/article/details/45914985" target="_blank" title="mysql 5.5 更改默认字符集">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 5.5 更改默认<em>字符集</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-22</span>
				<span class="read-num hover-hide">
					阅读数 
					3339</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/iastro/article/details/45914985" target="_blank" title="mysql 5.5 更改默认字符集">
				<span class="desc oneline">首先，MySQL的字符集问题主要是两个概念，一个是CharacterSets，一个是Collations，前者是字符内容及编码，后者是对前者进行比较操作的一些规则。这两个参数集可以在数据库实例、单个数...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/iastro">来自：	<span class="blog_title"> iastro的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_65" data-pid="65" data-track-view='{"mod":"kp_popu_65-84","con":",,"}' data-track-click='{"mod":"kp_popu_65-84","con":",,"}' data-report-view='{"mod":"kp_popu_65-84","keyword":""}' data-report-click='{"mod":"kp_popu_65-84","keyword":""}'><div id="three_ad33" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad33",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/a314537485/article/details/52302565","strategy":"BlogCommendFromAutoMl2","index":"34"}'>
	<div class="content">
		<a href="https://blog.csdn.net/a314537485/article/details/52302565" target="_blank" title="MySQL查看和修改字符集的方法">
		<h4 class="text-truncate oneline">
				<em>MySQL</em><em>查看</em>和<em>修改</em><em>字符集</em>的方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-24</span>
				<span class="read-num hover-hide">
					阅读数 
					1175</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/a314537485/article/details/52302565" target="_blank" title="MySQL查看和修改字符集的方法">
				<span class="desc oneline">MySQL查看和修改字符集的方法在这里简单记录一下mysql查看和修改字符集的方法，记录下来，同时也方便其他人使用：查看MySQL数据库服务器和数据库字符集查看mysql所支持的字符集查看表的字符集查...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/a314537485">来自：	<span class="blog_title"> 高峰的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/jack85986370/article/details/51454886","strategy":"BlogCommendFromBaidu","index":"35"}'>
	<div class="content">
		<a href="https://blog.csdn.net/jack85986370/article/details/51454886" target="_blank" title="linux  mysql 5.7 修改默认字符集为utf8">
		<h4 class="text-truncate oneline">
				linux  <em>mysql</em> 5.7 <em>修改</em>默认<em>字符集</em>为utf8		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-19</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/jack85986370/article/details/51454886" target="_blank" title="linux  mysql 5.7 修改默认字符集为utf8">
				<span class="desc oneline">1、通过 SHOWVARIABLESLIKE'character_set_%';查看mysql字符集情况mysql&gt;showvariableslike&quot;%char%&quot;;+---------------...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/jack85986370">来自：	<span class="blog_title"> Hello World .</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/shiwanwu/article/details/88044774","strategy":"BlogCommendFromBaidu","index":"36"}'>
	<div class="content">
		<a href="https://blog.csdn.net/shiwanwu/article/details/88044774" target="_blank" title="mysql8基础 create database 创建的数据库的名字是 关键字、特殊字符，用反引号">
		<h4 class="text-truncate oneline">
				<em>mysql</em>8基础 create database 创建的数据库的名字是 关键字、特殊字符，用反引号		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-28</span>
				<span class="read-num hover-hide">
					阅读数 
					277</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/shiwanwu/article/details/88044774" target="_blank" title="mysql8基础 create database 创建的数据库的名字是 关键字、特殊字符，用反引号">
				<span class="desc oneline">    &amp;amp;amp;nbsp;&amp;amp;amp;nbsp;OS:Ubuntu18.04.1LTS  &amp;amp;amp;nbsp;&amp;amp;amp;nbsp;&amp;amp;amp;nbsp;&amp;amp;...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/shiwanwu">来自：	<span class="blog_title"> 师万物</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/hpulfc/article/details/79564790","strategy":"BlogCommendFromBaidu","index":"37"}'>
	<div class="content">
		<a href="https://blog.csdn.net/hpulfc/article/details/79564790" target="_blank" title="数据库中的schema是什么（简）">
		<h4 class="text-truncate oneline">
				数据库中的schema是什么（简）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-15</span>
				<span class="read-num hover-hide">
					阅读数 
					2万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/hpulfc/article/details/79564790" target="_blank" title="数据库中的schema是什么（简）">
				<span class="desc oneline">数据库中的Schema突然想到数据库中的schema是什么，于是多方搜索有了基本了解，做一个简单记录：在SQL环境下，schema就是数据库对象的集合，所谓的数据库对象也就是常说的表，索引，视图，存储...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/hpulfc">来自：	<span class="blog_title"> 这里应该有一个很正经的标题的。！。！。！。！夏天来了</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box  recommend-other-item-box"  data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/392054424","strategy":"BlogCommendFromBaidu","index":"38"}'>
	<a href="https://bbs.csdn.net/topics/392054424" target="_blank">
		<h4 class="text-truncate oneline">
				创建数据库成功，刷新后显示的名字少了一个字；而且打开显示错误：1049-Unknown database ''		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">11-26</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">mysql&gt; create database '自行车管理系统'; 1064 - You have an error in your SQL syntax; check the manual that</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_66" data-pid="66" data-track-view='{"mod":"kp_popu_66-87","con":",,"}' data-track-click='{"mod":"kp_popu_66-87","con":",,"}' data-report-view='{"mod":"kp_popu_66-87","keyword":""}' data-report-click='{"mod":"kp_popu_66-87","keyword":""}'><div id="three_ad38" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad38",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/iteye_8264/article/details/82640928","strategy":"BlogCommendFromBaidu","index":"39"}'>
	<div class="content">
		<a href="https://blog.csdn.net/iteye_8264/article/details/82640928" target="_blank" title="MySQL查看所有可用的字符集">
		<h4 class="text-truncate oneline">
				<em>MySQL</em><em>查看</em>所有可用的<em>字符集</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-17</span>
				<span class="read-num hover-hide">
					阅读数 
					98</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/iteye_8264/article/details/82640928" target="_blank" title="MySQL查看所有可用的字符集">
				<span class="desc oneline">MySQL查看所有可用的字符集Enterpassword:WelcometotheMySQLmonitor.Commandsendwith;or\g.YourMySQLconnectionidis61...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/iteye_8264">来自：	<span class="blog_title"> 牛栏山矿泉水</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/fenixshadow/article/details/1958897","strategy":"BlogCommendFromAutoMl2","index":"40"}'>
	<div class="content">
		<a href="https://blog.csdn.net/fenixshadow/article/details/1958897" target="_blank" title="如何查看mysql的字符集">
		<h4 class="text-truncate oneline">
				如何<em>查看</em><em>mysql</em>的<em>字符集</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-22</span>
				<span class="read-num hover-hide">
					阅读数 
					2119</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/fenixshadow/article/details/1958897" target="_blank" title="如何查看mysql的字符集">
				<span class="desc oneline">查看mysql的字符集：mysql&gt;showvariableslikecharacter/_set/_%;+--------------------------+--------+|Variable_...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/fenixshadow">来自：	<span class="blog_title"> 凤影的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/leo__1990/article/details/93504528","strategy":"BlogCommendFromAutoMl2","index":"41"}'>
	<div class="content">
		<a href="https://blog.csdn.net/leo__1990/article/details/93504528" target="_blank" title="查看 MySQL 字符集的方法">
		<h4 class="text-truncate oneline">
				<em>查看</em> <em>MySQL</em> <em>字符集</em>的方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-24</span>
				<span class="read-num hover-hide">
					阅读数 
					225</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/leo__1990/article/details/93504528" target="_blank" title="查看 MySQL 字符集的方法">
				<span class="desc oneline">1MySQL字符集设置系统变量：–character_set_server：默认的内部操作字符集–character_set_client：客户端来源数据使用的字符集–character_set_co...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/leo__1990">来自：	<span class="blog_title"> leo__1990的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/jnx1142410525/article/details/70859366","strategy":"BlogCommendFromAutoMl2","index":"42"}'>
	<div class="content">
		<a href="https://blog.csdn.net/jnx1142410525/article/details/70859366" target="_blank" title="Mysql5.6版本字符集修改">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>5.6版本<em>字符集</em><em>修改</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-27</span>
				<span class="read-num hover-hide">
					阅读数 
					2955</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/jnx1142410525/article/details/70859366" target="_blank" title="Mysql5.6版本字符集修改">
				<span class="desc oneline">Mysql5.6版本字符集修改</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/jnx1142410525">来自：	<span class="blog_title"> 道问苍天的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/e8196417ping/article/details/80133584","strategy":"BlogCommendFromAutoMl2","index":"43"}'>
	<div class="content">
		<a href="https://blog.csdn.net/e8196417ping/article/details/80133584" target="_blank" title="再见乱码：5分钟读懂MySQL字符集设置">
		<h4 class="text-truncate oneline">
				再见乱码：5分钟读懂<em>MySQL</em><em>字符集</em>设置		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-09</span>
				<span class="read-num hover-hide">
					阅读数 
					558</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/e8196417ping/article/details/80133584" target="_blank" title="再见乱码：5分钟读懂MySQL字符集设置">
				<span class="desc oneline">一、内容概述在MySQL的使用过程中，了解字符集、字符序的概念，以及不同设置对数据存储、比较的影响非常重要。不少同学在日常工作中遇到的“乱码”问题，很有可能就是因为对字符集与字符序的理解不到位、设置错...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/e8196417ping">来自：	<span class="blog_title"> e8196417ping的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_67" data-pid="67" data-track-view='{"mod":"kp_popu_67-653","con":",,"}' data-track-click='{"mod":"kp_popu_67-653","con":",,"}' data-report-view='{"mod":"kp_popu_67-653","keyword":""}' data-report-click='{"mod":"kp_popu_67-653","keyword":""}'><div id="three_ad43" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : '9gAEHz',
                placeholderId: "three_ad43",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 16,
                    titleFontColor: '#000',
                    titleFontFamily : 'Microsoft Yahei',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 12,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/lploveme/article/details/8253939","strategy":"BlogCommendFromAutoMl2","index":"44"}'>
	<div class="content">
		<a href="https://blog.csdn.net/lploveme/article/details/8253939" target="_blank" title="MySql中的字符集和怎样选择字符集">
		<h4 class="text-truncate oneline">
				<em>MySql</em>中的<em>字符集</em>和怎样选择<em>字符集</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-03</span>
				<span class="read-num hover-hide">
					阅读数 
					5606</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/lploveme/article/details/8253939" target="_blank" title="MySql中的字符集和怎样选择字符集">
				<span class="desc oneline">字符集概述字符集是一套符号和编码的规则，不论是在oracle数据库还是在mysql数据库，都存在字符集的选择问题，而且如果在数据库创建阶段没有正确选择字符集，那么可能在后期需要更换字符集，而字符集的更...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/lploveme">来自：	<span class="blog_title"> 程序与人生</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/karen_wang/article/details/7338009","strategy":"BlogCommendFromBaidu","index":"45"}'>
	<div class="content">
		<a href="https://blog.csdn.net/karen_wang/article/details/7338009" target="_blank" title="修改及查看mysql数据库的字符集">
		<h4 class="text-truncate oneline">
				<em>修改</em>及<em>查看</em><em>mysql</em>数据库的<em>字符集</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-09</span>
				<span class="read-num hover-hide">
					阅读数 
					4万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/karen_wang/article/details/7338009" target="_blank" title="修改及查看mysql数据库的字符集">
				<span class="desc oneline">如下内容来自： http://www.cnblogs.com/donqiang/articles/2057972.htmlLiunx下修改MySQL字符集：1.查找MySQL的cnf文件的位置find...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/karen_wang">来自：	<span class="blog_title"> karen_wang的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/time_tries_all/article/details/78575363","strategy":"BlogCommendFromBaidu","index":"46"}'>
	<div class="content">
		<a href="https://blog.csdn.net/time_tries_all/article/details/78575363" target="_blank" title="Ubuntu 下修改MySQL的字符集为UTF-8">
		<h4 class="text-truncate oneline">
				Ubuntu 下<em>修改</em><em>MySQL</em>的<em>字符集</em>为UTF-8		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-19</span>
				<span class="read-num hover-hide">
					阅读数 
					561</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/time_tries_all/article/details/78575363" target="_blank" title="Ubuntu 下修改MySQL的字符集为UTF-8">
				<span class="desc oneline">在python中输入中文到数据库中全是乱码问号，MySQL不识别，是因为MySQL默认的字符集是latin1(ISO_8859_1)不是utf8的字符集。  修改方法：1.打开my.cnf文件进行修改...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/time_tries_all">来自：	<span class="blog_title"> time_tries_all的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/suiyujiangnan/article/details/52444444","strategy":"BlogCommendFromBaidu","index":"47"}'>
	<div class="content">
		<a href="https://blog.csdn.net/suiyujiangnan/article/details/52444444" target="_blank" title="mysql 5.7版本修改编码为utf-8">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 5.7版本<em>修改</em>编码为utf-8		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-05</span>
				<span class="read-num hover-hide">
					阅读数 
					7235</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/suiyujiangnan/article/details/52444444" target="_blank" title="mysql 5.7版本修改编码为utf-8">
				<span class="desc oneline">刚开始学习mysql，下载的是官网最新版本5..7.14，使用cmd输入中文时报错，于是开始修改mysql默认编码(windows下)首先通过 showvariableslike'character_...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/suiyujiangnan">来自：	<span class="blog_title"> suiyujiangnan的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/Ouitiken/article/details/23171327","strategy":"BlogCommendFromBaidu","index":"48"}'>
	<div class="content">
		<a href="https://blog.csdn.net/Ouitiken/article/details/23171327" target="_blank" title="CentOS查看和修改MySQL字符集">
		<h4 class="text-truncate oneline">
				CentOS<em>查看</em>和<em>修改</em><em>MySQL</em><em>字符集</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-08</span>
				<span class="read-num hover-hide">
					阅读数 
					9478</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/Ouitiken/article/details/23171327" target="_blank" title="CentOS查看和修改MySQL字符集">
				<span class="desc oneline">客户提供了MySQL的环境showvariableslike'character_set%';</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/Ouitiken">来自：	<span class="blog_title"> 小轶的学习笔记</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_68" data-pid="68" data-track-view='{"mod":"kp_popu_68-654","con":",,"}' data-track-click='{"mod":"kp_popu_68-654","con":",,"}' data-report-view='{"mod":"kp_popu_68-654","keyword":""}' data-report-click='{"mod":"kp_popu_68-654","keyword":""}'><div id="three_ad48" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad48",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 16,
                    titleFontColor: '#000',
                    titleFontFamily : 'Microsoft Yahei',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/flcandclf/article/details/24769599","strategy":"BlogCommendFromBaidu","index":"49"}'>
	<div class="content">
		<a href="https://blog.csdn.net/flcandclf/article/details/24769599" target="_blank" title="MySQL数据库、数据表和字段字符集查询、修改和配置">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>数据库、数据表和字段<em>字符集</em>查询、<em>修改</em>和配置		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-30</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/flcandclf/article/details/24769599" target="_blank" title="MySQL数据库、数据表和字段字符集查询、修改和配置">
				<span class="desc oneline">一、设置编码LINUX  修改vi/etc/my.cnfWINDOWSmy.ini　　在[client]下添加　　  default-character-set=utf8 　　在[mysqld]下添加...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/flcandclf">来自：	<span class="blog_title"> 怪手大分的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
                <div class="recommend-item-box type_hot_word">
                                <div class="content clearfix">
                    <div class="word float-left">
                                                            <span>
                        <a href="https://edu.csdn.net/courses/o5329_s5330_k " target="_blank">
                        机器学习教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/courses/o280_s351_k " target="_blank">
                        Objective-C培训                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o7115_s388_l0_t " target="_blank">
                        交互设计视频教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/course/play/5599/104252 " target="_blank">
                        颜色模型                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o363_l0_t " target="_blank">
                        设计制作学习                    </a></span>
                                                            </div>
                </div>
                                                <div class="content clearfix">
                    <div class="float-left">
                                        <span>
                        <a href="https://www.csdn.net/gather_24/MtTaEg3sMDM5MS1ibG9n.html" target="_blank">
                        mysql关联查询两次本表</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_10/MtjaIg3sMTUzMy1kb3dubG9hZAO0O0OO0O0O.html" target="_blank">
                        native底部 react</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_1b/Ntzagg1sOTU3LWRvd25sb2Fk.html" target="_blank">
                        extjs glyph 图标</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/MtjaQg3sNDgtZWR1.html" target="_blank">
                        数据库修改课程</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/Mtzacg3sNzUtZWR1.html" target="_blank">
                        ios开发修改视频尺寸</a>
                    </span>
                                        </div>
                </div>
                                </div>
                            <div class="recommend-loading-box">
                <img src='https://csdnimg.cn/release/phoenix/images/feedLoading.gif'>
            </div>
            <div class="recommend-end-box">
                <p class="text-center">没有更多推荐了，<a href="https://blog.csdn.net/" class="c-blue c-blue-hover c-blue-focus">返回首页</a></p>
            </div>
        </div>
    </main>

    <aside>
	<div id="asideProfile" class="aside-box">
    <!-- <h3 class="aside-title">个人资料</h3> -->
    <div class="profile-intro d-flex">
        <div class="avatar-box d-flex justify-content-center flex-column">
            <a href="https://blog.csdn.net/qq_37187976">
              <img src="https://avatar.csdn.net/7/F/F/3_qq_37187976.jpg" class="avatar_pic">
                              <img src="https://g.csdnimg.cn/static/user-reg-year/1x/3.png" class="user-years">
                          </a>
            
        </div>
        <div class="user-info d-flex justify-content-center flex-column">
            <p class="name csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                <a href="https://blog.csdn.net/qq_37187976"  class="" id="uid">咻一咻</a>
            </p>
                    </div>
                <div class="opt-box d-flex justify-content-center flex-column">
            <span  class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                                    <a class="btn btn-sm btn-red-hollow attention" id="btnAttent">关注</a>
                            </span>
        </div>
            </div>
    <div class="data-info d-flex item-tiling">
                <dl class="text-center" title="94">
                        <dt><a href="https://blog.csdn.net/qq_37187976?t=1">原创</a></dt>
            <dd><a href="https://blog.csdn.net/qq_37187976?t=1"><span class="count">94</span></a></dd>
                    </dl>
        <dl class="text-center" id="fanBox" title="47">
            <dt>粉丝</dt>
            <dd><span class="count" id="fan">47</span></dd>
        </dl>
        <dl class="text-center" title="42">
            <dt>喜欢</dt>
            <dd><span class="count">42</span></dd>
        </dl>
        <dl class="text-center" title="36">
            <dt>评论</dt>
            <dd><span class="count">36</span></dd>
        </dl>
    </div>
    <div class="grade-box clearfix">
        <dl>
            <dt>等级：</dt>
            <dd>
                <a href="https://blog.csdn.net/home/help.html#level" title="5级,点击查看等级说明" target="_blank">
                    <svg class="icon icon-level" aria-hidden="true">
                        <use xlink:href="#csdnc-bloglevel-5"></use>
                    </svg>
                </a>
            </dd>
        </dl>
        <dl>
            <dt>访问：</dt>
            <dd title="149435">
                14万+            </dd>
        </dl>
        <dl>
            <dt>积分：</dt>
            <dd title="2404">
                2404            </dd>
        </dl>
        <dl title="27521">
            <dt>排名：</dt>
            <dd>2万+</dd>
        </dl>
    </div>
        <div class="badge-box d-flex">
        <span>勋章：</span>
        <div class="badge d-flex">
                                                        <div class="icon-badge" title="专栏达人">
                       <div class="mouse-box">
                          <img src="https://g.csdnimg.cn/static/user-medal/zhuanlan.svg" alt="">
                          <div class="icon-arrow"></div>
                       </div>
                       <div class="grade-detail-box">
                           <div class="pos-box">
                               <div class="left-box d-flex justify-content-center align-items-center flex-column">
                                    <img src="https://g.csdnimg.cn/static/user-medal/zhuanlan.svg" alt="">
                                   <p>专栏达人</p>
                               </div>
                               <div class="right-box">
                                   授予成功创建个人博客专栏的用户。专栏中添加五篇以上博文即可点亮！撰写博客专栏浓缩技术精华，专栏达人就是你！                               </div>
                           </div>
                       </div>
                   </div>
                                             </div>
        <script>
            (function ($) {
                setTimeout(function(){
                    $('div.icon-badge.show-moment').removeClass('show-moment');
                }, 5000);
            })(window.jQuery)
        </script>
    </div>
        <div class="personal-home-page"><a target="_blank"  href="https://me.csdn.net/qq_37187976">TA的个人主页 ></a></div>
</div>
<div class="csdn-tracking-statistics mb8 box-shadow" data-pid="blog" data-report-click='{"mod":"popu_4"}' data-report-view='{"mod":"popu_4"}' style="height:250px;">
    <div class="aside-content text-center" id="cpro_u2734133">
      <div id="kp_box_56" data-pid="56" data-track-view='{"mod":"kp_popu_56-703","con":",,"}' data-track-click='{"mod":"kp_popu_56-703","con":",,"}' data-report-view='{"mod":"kp_popu_56-703","keyword":""}' data-report-click='{"mod":"kp_popu_56-703","keyword":""}'><script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- 博客内页左上视窗-20181120 -->
<ins class="adsbygoogle"
     style="display:inline-block;width:300px;height:250px"
     data-ad-client="ca-pub-1076724771190722"
     data-ad-slot="7700527946"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script></div>    </div>
</div>
<div id="asideArchive" class="aside-box flexible-box">
    <h3 class="aside-title">归档</h3>
    <div class="aside-content">
        <ul class="archive-list">
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_37187976/article/month/2019/03">
                    2019年3月                    <span class="count float-right">7篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_37187976/article/month/2018/08">
                    2018年8月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_37187976/article/month/2018/07">
                    2018年7月                    <span class="count float-right">5篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_37187976/article/month/2018/06">
                    2018年6月                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_37187976/article/month/2018/05">
                    2018年5月                    <span class="count float-right">5篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_37187976/article/month/2018/04">
                    2018年4月                    <span class="count float-right">6篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_37187976/article/month/2018/03">
                    2018年3月                    <span class="count float-right">25篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_37187976/article/month/2018/02">
                    2018年2月                    <span class="count float-right">8篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq_37187976/article/month/2018/01">
                    2018年1月                    <span class="count float-right">44篇</span>
                </a>
            </li>
                    </ul>
    </div>
        <p class="text-center">
        <a class="btn btn-link-blue flexible-btn" data-fbox="aside-archive">展开</a>
    </p>
    </div>
<div id="asideNewArticle" class="aside-box">
    <h3 class="aside-title">最新文章</h3>
    <div class="aside-content">
        <ul class="inf_list clearfix csdn-tracking-statistics tracking-click" data-mod="popu_382">
                        <li class="clearfix">
                <a href="https://blog.csdn.net/qq_37187976/article/details/88899195" target="_blank" >
                                        Navicat连接内网的MySQL（阿里云，腾讯云）！！！                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/qq_37187976/article/details/88800062" target="_blank" >
                                        一、什么是zabbbix？                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/qq_37187976/article/details/88799363" target="_blank" >
                                        二、zabbix安装                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/qq_37187976/article/details/88795558" target="_blank" >
                                        centos7 yum配置安装Mariadb数据库                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/qq_37187976/article/details/88695940" target="_blank" >
                                        安装SSL检查提示“错误： 服务器缺少中间证书”                </a>
            </li>
                    </ul>
    </div>
</div>
<div id="asideColumn" class="aside-box">
    <h3 class="aside-title">博主专栏</h3>
    <div class="aside-content">
        <ul class="column-box csdn-tracking-statistics tracking-click" data-report-view='{"mod":"popu_520"}' >
                            <li class="clearfix">
                    <div class="img-box float-left">
                        <a class="d-flex align-items-center" href="https://blog.csdn.net/qq_37187976/column/info/20823">
                            <img src="//img-blog.csdn.net/20180704115415809?imageView2/5/w/120/h/120" alt="">
                        </a>
                    </div>
                    <div class="info">
                        <p class="title"><a href="https://blog.csdn.net/qq_37187976/column/info/20823">Nginx</a></p>
                        <div class="data">文章数：<span class="count">11 篇</span> 访问量：<span>3081</span></div>
                    </div>
                </li>
                    </ul>
    </div>
    </div>
<div id="asideCategory" class="aside-box flexible-box">
    <h3 class="aside-title">个人分类</h3>
    <div class="aside-content">
        <ul>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_37187976/article/category/7409417">
                    <span class="title oneline">编辑</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_37187976/article/category/7409833">
                    <span class="title oneline">linux</span>
                    <span class="count float-right">44篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_37187976/article/category/7410541">
                    <span class="title oneline">Chrome</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_37187976/article/category/7414072">
                    <span class="title oneline">运维</span>
                    <span class="count float-right">6篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_37187976/article/category/7414096">
                    <span class="title oneline">数据库</span>
                    <span class="count float-right">6篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_37187976/article/category/7415060">
                    <span class="title oneline">DNS</span>
                    <span class="count float-right">5篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_37187976/article/category/7420153">
                    <span class="title oneline">linux命令</span>
                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_37187976/article/category/7423244">
                    <span class="title oneline">接口</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_37187976/article/category/7423263">
                    <span class="title oneline">存储</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_37187976/article/category/7424314">
                    <span class="title oneline">随笔</span>
                    <span class="count float-right">9篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_37187976/article/category/7424677">
                    <span class="title oneline">计算机专业术语</span>
                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_37187976/article/category/7424775">
                    <span class="title oneline">httpd</span>
                    <span class="count float-right">5篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_37187976/article/category/7433432">
                    <span class="title oneline">LAMP</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_37187976/article/category/7443594">
                    <span class="title oneline">运维自动化</span>
                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_37187976/article/category/7533582">
                    <span class="title oneline">工具</span>
                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_37187976/article/category/7552871">
                    <span class="title oneline">趣图</span>
                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_37187976/article/category/7640439">
                    <span class="title oneline">问题</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_37187976/article/category/7776740">
                    <span class="title oneline">病毒</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_37187976/article/category/7796507">
                    <span class="title oneline">服务器配置</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_37187976/article/category/7913864">
                    <span class="title oneline">监控</span>
                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_37187976/article/category/8727055">
                    <span class="title oneline">mysql</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq_37187976/article/category/8792675">
                    <span class="title oneline">MariaDB</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                    </ul>
    </div>
        <p class="text-center">
        <a class="btn btn-link-blue flexible-btn" data-fbox="aside-archive">展开</a>
    </p>
    </div>
<div id="asideHotArticle" class="aside-box">
	<h3 class="aside-title">热门文章</h3>
	<div class="aside-content">
		<ul class="hotArticle-list csdn-tracking-statistics tracking-click" data-report-view='{"mod":"popu_521"}'>
							<li>

					<a href="https://blog.csdn.net/qq_37187976/article/details/79117863" >
                                                浅谈MySQL和MariaDB区别?                    </a>
					<p class="read">阅读数 <span>13049</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/qq_37187976/article/details/79160050" >
                                                免费IP地址查询API接口                    </a>
					<p class="read">阅读数 <span>12172</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/qq_37187976/article/details/79096742" >
                                                CentOS（6、7）修改主机名(hostname)                    </a>
					<p class="read">阅读数 <span>11105</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/qq_37187976/article/details/80626528" >
                                                修改ssh默认端口                    </a>
					<p class="read">阅读数 <span>10492</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/qq_37187976/article/details/79265667" >
                                                echo 命令显示带颜色的字                    </a>
					<p class="read">阅读数 <span>6306</span></p>
				</li>
					</ul>
	</div>
</div>
<div id="asideNewComments" class="aside-box">
    <h3 class="aside-title">最新评论</h3>
    <div class="aside-content">
        <ul class="newcomment-list">
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/qq_37187976/article/details/79101776#comments">吐血推荐珍藏的Chrome插件</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/qq_42362207" class="user-name" target="_blank">qq_42362207：</a>标记                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/qq_37187976/article/details/80626528#comments">修改ssh默认端口</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/vainquit" class="user-name" target="_blank">vainquit：</a>十分感谢。我今天就为了这端口搞了1个小时，我就在想TMD为什么我怎么设置端口都无效的？原来是注释没有去掉，吐血。。。                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/qq_37187976/article/details/79211951#comments">apache2.4版本与2.2版本...</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/tunpishuang" class="user-name" target="_blank">tunpishuang：</a>卸载-&gt;写在                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/qq_37187976/article/details/80191547#comments">如何管理自己的时间？</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/Kimsohyuna" class="user-name" target="_blank">Kimsohyuna：</a>6666                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/qq_37187976/article/details/80626528#comments">修改ssh默认端口</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/qq_37187976" class="user-name" target="_blank">qq_37187976：</a>[reply]K346K346[/reply]
已修改，谢谢                </p>
            </li>
                    </ul>
    </div>
</div>
	<div id="asideFooter">
			
		<div class="aside-box">
			<div id="kp_box_57" data-pid="57" data-track-view='{"mod":"kp_popu_57-707","con":",,"}' data-track-click='{"mod":"kp_popu_57-707","con":",,"}' data-report-view='{"mod":"kp_popu_57-707","keyword":""}' data-report-click='{"mod":"kp_popu_57-707","keyword":""}'><script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- 博客内页左下视窗-20181130 -->
<ins class="adsbygoogle"
     style="display:inline-block;width:300px;height:250px"
     data-ad-client="ca-pub-1076724771190722"
     data-ad-slot="1894159733"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script></div>		</div>
				<div class="aside-box">
			<div class="persion_article">
			</div>
		</div>
	</div>
</aside>
<script src="https://csdnimg.cn/pubfooter/js/publib_footer-1.0.3.js" data-isfootertrack="false" type="text/javascript"></script>
<script>
	$("a.flexible-btn").click(function(){
		$(this).parents('div.aside-box').removeClass('flexible-box');
		$(this).remove();
	})
</script>
</div>
<div class="mask-dark"></div>
<div class="tool-box vertical">
    	<ul class="meau-list">
		<li class="btn-like-box ">
			<button class=" low-height hover-box btn-like " title="点赞">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup"></use>
				</svg>
				<span class="hover-show text-box text">
					<span class="no-active">点赞</span>
					<span class="active">取消点赞</span>
				</span>
				<p id="supportCount">0</p>
			</button>
		</li>
		<li class="to-commentBox">
						<a class="btn-comments low-height hover-box" title="写评论" href="#commentBox">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-comments"></use>
				</svg>
				<span class="hover-show text">评论</span>
				<p class="">
										</p>
			</a>
		</li>
		<li class="toc-container-box" id="liTocBox">
			<a class="btn-toc low-height hover-box btn-comments" title="目录">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-contents"></use>
				</svg>
				<span class="hover-show text">目录</span>
			</a>
			<div class="toc-container">
				<div class="pos-box">
					<div class="icon-arrow"></div>
					<div class="scroll-box">
						<div class="toc-box"></div>
					</div>
				</div>
				<div class="opt-box">
					<button class="btn-opt prev nomore" title="向上">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevronup"></use>
						</svg>
					</button>
					<button class="btn-opt next">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevrondown"></use>
						</svg>
					</button>
				</div>
			</div>
		</li>
		<li>
			<a class="btn-bookmark low-height hover-box btn-comments" title="收藏">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark"></use>
				</svg>
					<span class="hover-show text">收藏</span>
				<!-- <span class="hover-show text-box text">
					<span class="no-active">收藏</span>
					<span class="active">取消收藏</span>
				</span> -->
			</a>
		</li>
		<li class="bdsharebuttonbox">
			<div class="weixin-qr btn-comments low-height hover-box" >
        <a href="#" class="bds_weixin clear-share-style" data-cmd="weixin" title="手机看"></a>
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-usephone"></use>
				</svg>
				<span class="hover-show text text3">
					手机看
				</span>
			</div>
		</li>
							<li class="widescreen-hide">
				<a class="prev btn-comments low-height hover-box" href="https://blog.csdn.net/qq_37187976/article/details/80199249" title="Existing lock /var/run/yum.pid: another copy is running as pid 解决办法?">
					<svg class="icon hover-hide" aria-hidden="true">
						<use xlink:href="#csdnc-chevronleft"></use>
					</svg>
					<span class="hover-show text text3">上一篇</span>
				</a>
			</li>
								<li class="widescreen-hide">
			<a class="next btn-comments hover-box low-height" href="https://blog.csdn.net/qq_37187976/article/details/80626528" title="修改ssh默认端口">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-chevronright"></use>
				</svg>
				<span class="hover-show text text3">下一篇</span>
			</a>
		</li>
						<!-- 宽屏更多按钮 -->
		<li class="widescreen-more">
			<a class="btn-comments chat-ask-button low-height hover-box" title="快问" href="#chatqa">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-more"></use>
				</svg>
				<span class="hover-show text">更多</span>
				
			</a>
			<ul class="widescreen-more-box">
													<li class="widescreen-more">
						<a class="btn-comments low-height hover-box" href="https://blog.csdn.net/qq_37187976/article/details/80199249" title="Existing lock /var/run/yum.pid: another copy is running as pid 解决办法?">
							<svg class="icon hover-hide" aria-hidden="true">
								<use xlink:href="#csdnc-chevronleft"></use>
							</svg>
							<span class="hover-show text text3">上一篇</span>
						</a>
					</li>
																<li class="widescreen-more">
					<a class="btn-comments hover-box low-height" href="https://blog.csdn.net/qq_37187976/article/details/80626528" title="修改ssh默认端口">
						<svg class="icon hover-hide" aria-hidden="true">
							<use xlink:href="#csdnc-chevronright"></use>
						</svg>
						<span class="hover-show text text3">下一篇</span>
					</a>
				</li>
							</ul>
		</li>
	</ul>
</div>
<script>window._bd_share_config = { "common": { "bdSnsKey": {}, "bdText": "", "bdMini": "1", "bdMiniList": false, "bdPic": "", "bdStyle": "0", "bdSize": "16" }, "share": {} }; with (document) 0[(getElementsByTagName('head')[0] || body).appendChild(createElement('script')).src = 'https://csdnimg.cn/static/api/js/share.js?v=89860594'];</script>
<script src="https://g.csdnimg.cn/collection-box/1.0.0/collection-box.js?t=20190710173809" type="text/javascript"></script><script>
    var recommendCount = 50;
    recommendCount = recommendCount > 1 ? (recommendCount + (recommendCount>6 ? 2 : 1)) : recommendCount;
    var ChannelId = 6;
    var articleId = "80494668";
    var commentscount = 0;
    var islock = false;
    var curentUrl = "https://blog.csdn.net/qq_37187976/article/details/80494668";
    var myUrl = "https://my.csdn.net/";
    //1禁止评论，2正常
    var commentAuth = 2;
    //百度搜索
    var baiduKey = "mysql 查看与修改字符集？ - 咻一咻的博客";
    var needInsertBaidu = true;
    // 代码段样式
    var codeStyle = '';
	var highlight = ["mysql","\u67e5\u770b","\u4fee\u6539","\u5b57\u7b26\u96c6"];//高亮数组

    var RecommendBlogExpertList = [];
	var articleType = 1;
	var CopyrightContent = '本文为博主原创文章，未经博主允许不得转载。';
</script>
<script src="https://csdnimg.cn/public/sandalstrap/1.4/js/sandalstrap.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-3d3b805766.js"></script>


<div style="display:none;">
	<img src="" onerror='setTimeout(function(){if(!/(csdn.net|iteye.com|baiducontent.com|googleusercontent.com|360webcache.com|sogoucdn.com|bingj.com|baidu.com)$/.test(window.location.hostname)){window.location.href="\x68\x74\x74\x70\x73\x3a\x2f\x2f\x77\x77\x77\x2e\x63\x73\x64\x6e\x2e\x6e\x65\x74"}},3000);'>
</div>
</body>

	<link rel="stylesheet" href="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/codesnippet/lib/highlight/styles/atom-one-light.css">
	<script type="text/javascript" src="https://csdnimg.cn/release/phoenix/production/pc_wap_common-f868939e52.js" /></script>

<script src="https://csdnimg.cn/release/phoenix/template/js/common-37b7aadaf4.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/template/js/detail-1e5a65cde8.min.js"></script>

	<script src="https://csdnimg.cn/release/phoenix/themes/skin3-template/skin3-template-fc7383b956.min.js"></script>
<script>
 // 全局声明
 if (window.csdn === undefined) {
      window.csdn = {};
    }
    window.csdn.sideToolbar = {
        options: {
            report:{
                isShow: true,
            },
            afterFinished: function(){
                setTimeout(function () {
                    var viphtml = '<a class="option-box" data-type="vip" href="https://mall.csdn.net/vip" target="_blank">'+
                        '<img src="https://g.csdnimg.cn/side-toolbar/1.4/images/vip.png" alt="" srcset="">'+
                        '<span class="show-txt">VIP<br>免广告</span>'+
                        '</a>';
                    $('.csdn-side-toolbar').prepend(viphtml)
                },300)
            }
        }
    }

    $(function(){
        $(document).on('click',"a.option-box[data-type='report']",function() {
            showReport(false,articleTitles)
        });
    })
</script>
<script src="https://g.csdnimg.cn/side-toolbar/1.4/side-toolbar.js"></script>

    <script src="//g.csdnimg.cn/??login-box/1.0.6/login-box.js,login-box/1.0.7/login-auto.js,copyright/1.0.3/copyright.js,baidu-search/1.0.0/baidu-search.js?t=20190307095522"  type="text/javascript"></script>

<script type="text/javascript" src="https://csdnimg.cn/release/blog_mathjax/MathJax.js?config=TeX-AMS-MML_HTMLorMML"></script>
<script type="text/x-mathjax-config">
    MathJax.Hub.Config({
            "HTML-CSS": {
                    linebreaks: { automatic: true, width: "94%container" },
                    imageFont: null
            },
            tex2jax: {
                preview: "none"
            },
            mml2jax: {
                preview: 'none'
            }
    });
</script>
<script type="text/javascript">
    </script>
<script src="https://gh.bdstatic.com/static/gh/js/sdk/bword.min.js"></script>
</html>
